All Questions
Tagged with powershellexcel
8 questions
2votes
1answer
467views
ImportExcel for Dataset with Multiple tables
I need to be able to create an Excel document with multiple tabs for a dataset with multiple results\data tables. I have a stored procedure with 3 selects in them, fairly simple ones pulling data from ...
- 21
7votes
2answers
2kviews
Remove known Excel passwords with PowerShell
I have this PowerShell code that loops through Excel files in a specified directory; references a list of known passwords to find the correct one; and then opens, decrypts, and saves that file to a ...
- 171
3votes
1answer
6kviews
Batch convert txt files to xls
In this SO question I provided two answers for the batch conversion of more than 100K txt to xlsx files I suspect any automation of Excel is too slow, but would appreciate if there is a superior (i....
- 193
5votes
2answers
502views
Getting NTFS permissions of all shared folders on the local machine
How can I improve the speed of the script? ...
- 295
6votes
2answers
7kviews
PowerShell script to create Excel spreadsheet from HTML file
This script is designed to create an Excel spreadsheet from each HTML table from auto-generated index.html file. It needs to be very robust but unfortunately I ...
5votes
1answer
992views
Powershell Interaction with Excel (Highlighting Cells)
I'm using Powershell to compare two, large csv files and output the rows which don't match. Once the two output files are made (one for the differences on each), I bring them up on Excel. Now I want ...
- 181
7votes
1answer
1kviews
Import Excel, unpivot data, output tab-delimited for SQL Import
I have a client GL file (Excel) that needs to be regularly imported to SQL Server (as tab-delimited txt). Sample (simplified): ...
- 215
9votes
2answers
18kviews
Powershell script for manipulating Excel files
I have a directory of .xls workbooks with the following naming convention: 001.WIP Monthly Report 002.WIP Joes Custom Report ... 129.PUR Supplier Spend The number ...
